home *** CD-ROM | disk | FTP | other *** search

---

/ Developer Source 12 / Developer Source Volume 12 (I-MODE Publications, Inc.)(1999).iso / orinf / mar97 / hipsf102.gif

< prev

next >

Graphics Interchange Format  |  1998-02-10  |  22KB  |  333x320  |  4-bit (16 colors)

Labels: text | electronics | screenshot | display | software | number
OCR: Oracle Procedure Builder File Edit Tools Window Help Stored Program Unit . SCOTT ANNUM _ SAL_UPDATE Now ISayel Hevet Diep Cloud SCOTT # Name ANNUAL_SAL_UPDATE (Proc PROCEDURE annual_sal_update IS emp nua number; new_sal number ; cursor new salaries is select empno, sal_increase(empno) BEGIN From emp; open new salaries; 1cop fetch new_salaries into emp_num, new_sal; if new salaries NOTFOUND then exit; end if; update cap set sal = new_sal where empno = emp_num; end loop; close new salaries; END No Moddied Figure 2: A procedure that updates employee salaries,

---